package com.esun.payment_api.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class InvFormExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public InvFormExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUuidIsNull() {
            addCriterion("UUID is null");
            return (Criteria) this;
        }

        public Criteria andUuidIsNotNull() {
            addCriterion("UUID is not null");
            return (Criteria) this;
        }

        public Criteria andUuidEqualTo(String value) {
            addCriterion("UUID =", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotEqualTo(String value) {
            addCriterion("UUID <>", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidGreaterThan(String value) {
            addCriterion("UUID >", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidGreaterThanOrEqualTo(String value) {
            addCriterion("UUID >=", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidLessThan(String value) {
            addCriterion("UUID <", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidLessThanOrEqualTo(String value) {
            addCriterion("UUID <=", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidLike(String value) {
            addCriterion("UUID like", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotLike(String value) {
            addCriterion("UUID not like", value, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidIn(List<String> values) {
            addCriterion("UUID in", values, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotIn(List<String> values) {
            addCriterion("UUID not in", values, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidBetween(String value1, String value2) {
            addCriterion("UUID between", value1, value2, "uuid");
            return (Criteria) this;
        }

        public Criteria andUuidNotBetween(String value1, String value2) {
            addCriterion("UUID not between", value1, value2, "uuid");
            return (Criteria) this;
        }

        public Criteria andCoIdIsNull() {
            addCriterion("CO_ID is null");
            return (Criteria) this;
        }

        public Criteria andCoIdIsNotNull() {
            addCriterion("CO_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCoIdEqualTo(Short value) {
            addCriterion("CO_ID =", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdNotEqualTo(Short value) {
            addCriterion("CO_ID <>", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdGreaterThan(Short value) {
            addCriterion("CO_ID >", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdGreaterThanOrEqualTo(Short value) {
            addCriterion("CO_ID >=", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdLessThan(Short value) {
            addCriterion("CO_ID <", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdLessThanOrEqualTo(Short value) {
            addCriterion("CO_ID <=", value, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdIn(List<Short> values) {
            addCriterion("CO_ID in", values, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdNotIn(List<Short> values) {
            addCriterion("CO_ID not in", values, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdBetween(Short value1, Short value2) {
            addCriterion("CO_ID between", value1, value2, "coId");
            return (Criteria) this;
        }

        public Criteria andCoIdNotBetween(Short value1, Short value2) {
            addCriterion("CO_ID not between", value1, value2, "coId");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andFlowStatusIsNull() {
            addCriterion("FLOW_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andFlowStatusIsNotNull() {
            addCriterion("FLOW_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andFlowStatusEqualTo(String value) {
            addCriterion("FLOW_STATUS =", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotEqualTo(String value) {
            addCriterion("FLOW_STATUS <>", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusGreaterThan(String value) {
            addCriterion("FLOW_STATUS >", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusGreaterThanOrEqualTo(String value) {
            addCriterion("FLOW_STATUS >=", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusLessThan(String value) {
            addCriterion("FLOW_STATUS <", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusLessThanOrEqualTo(String value) {
            addCriterion("FLOW_STATUS <=", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusLike(String value) {
            addCriterion("FLOW_STATUS like", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotLike(String value) {
            addCriterion("FLOW_STATUS not like", value, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusIn(List<String> values) {
            addCriterion("FLOW_STATUS in", values, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotIn(List<String> values) {
            addCriterion("FLOW_STATUS not in", values, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusBetween(String value1, String value2) {
            addCriterion("FLOW_STATUS between", value1, value2, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andFlowStatusNotBetween(String value1, String value2) {
            addCriterion("FLOW_STATUS not between", value1, value2, "flowStatus");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNull() {
            addCriterion("CREATE_BY is null");
            return (Criteria) this;
        }

        public Criteria andCreateByIsNotNull() {
            addCriterion("CREATE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByEqualTo(Short value) {
            addCriterion("CREATE_BY =", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotEqualTo(Short value) {
            addCriterion("CREATE_BY <>", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThan(Short value) {
            addCriterion("CREATE_BY >", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByGreaterThanOrEqualTo(Short value) {
            addCriterion("CREATE_BY >=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThan(Short value) {
            addCriterion("CREATE_BY <", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByLessThanOrEqualTo(Short value) {
            addCriterion("CREATE_BY <=", value, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByIn(List<Short> values) {
            addCriterion("CREATE_BY in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotIn(List<Short> values) {
            addCriterion("CREATE_BY not in", values, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByBetween(Short value1, Short value2) {
            addCriterion("CREATE_BY between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateByNotBetween(Short value1, Short value2) {
            addCriterion("CREATE_BY not between", value1, value2, "createBy");
            return (Criteria) this;
        }

        public Criteria andCreateAtIsNull() {
            addCriterion("CREATE_AT is null");
            return (Criteria) this;
        }

        public Criteria andCreateAtIsNotNull() {
            addCriterion("CREATE_AT is not null");
            return (Criteria) this;
        }

        public Criteria andCreateAtEqualTo(Date value) {
            addCriterion("CREATE_AT =", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtNotEqualTo(Date value) {
            addCriterion("CREATE_AT <>", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtGreaterThan(Date value) {
            addCriterion("CREATE_AT >", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_AT >=", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtLessThan(Date value) {
            addCriterion("CREATE_AT <", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_AT <=", value, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtIn(List<Date> values) {
            addCriterion("CREATE_AT in", values, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtNotIn(List<Date> values) {
            addCriterion("CREATE_AT not in", values, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtBetween(Date value1, Date value2) {
            addCriterion("CREATE_AT between", value1, value2, "createAt");
            return (Criteria) this;
        }

        public Criteria andCreateAtNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_AT not between", value1, value2, "createAt");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNull() {
            addCriterion("UPDATE_BY is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByIsNotNull() {
            addCriterion("UPDATE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByEqualTo(Short value) {
            addCriterion("UPDATE_BY =", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotEqualTo(Short value) {
            addCriterion("UPDATE_BY <>", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThan(Short value) {
            addCriterion("UPDATE_BY >", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByGreaterThanOrEqualTo(Short value) {
            addCriterion("UPDATE_BY >=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThan(Short value) {
            addCriterion("UPDATE_BY <", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByLessThanOrEqualTo(Short value) {
            addCriterion("UPDATE_BY <=", value, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByIn(List<Short> values) {
            addCriterion("UPDATE_BY in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotIn(List<Short> values) {
            addCriterion("UPDATE_BY not in", values, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByBetween(Short value1, Short value2) {
            addCriterion("UPDATE_BY between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateByNotBetween(Short value1, Short value2) {
            addCriterion("UPDATE_BY not between", value1, value2, "updateBy");
            return (Criteria) this;
        }

        public Criteria andUpdateAtIsNull() {
            addCriterion("UPDATE_AT is null");
            return (Criteria) this;
        }

        public Criteria andUpdateAtIsNotNull() {
            addCriterion("UPDATE_AT is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateAtEqualTo(Date value) {
            addCriterion("UPDATE_AT =", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtNotEqualTo(Date value) {
            addCriterion("UPDATE_AT <>", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtGreaterThan(Date value) {
            addCriterion("UPDATE_AT >", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_AT >=", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtLessThan(Date value) {
            addCriterion("UPDATE_AT <", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_AT <=", value, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtIn(List<Date> values) {
            addCriterion("UPDATE_AT in", values, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtNotIn(List<Date> values) {
            addCriterion("UPDATE_AT not in", values, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtBetween(Date value1, Date value2) {
            addCriterion("UPDATE_AT between", value1, value2, "updateAt");
            return (Criteria) this;
        }

        public Criteria andUpdateAtNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_AT not between", value1, value2, "updateAt");
            return (Criteria) this;
        }

        public Criteria andDeleteByIsNull() {
            addCriterion("DELETE_BY is null");
            return (Criteria) this;
        }

        public Criteria andDeleteByIsNotNull() {
            addCriterion("DELETE_BY is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteByEqualTo(Short value) {
            addCriterion("DELETE_BY =", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByNotEqualTo(Short value) {
            addCriterion("DELETE_BY <>", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByGreaterThan(Short value) {
            addCriterion("DELETE_BY >", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETE_BY >=", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByLessThan(Short value) {
            addCriterion("DELETE_BY <", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByLessThanOrEqualTo(Short value) {
            addCriterion("DELETE_BY <=", value, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByIn(List<Short> values) {
            addCriterion("DELETE_BY in", values, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByNotIn(List<Short> values) {
            addCriterion("DELETE_BY not in", values, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByBetween(Short value1, Short value2) {
            addCriterion("DELETE_BY between", value1, value2, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteByNotBetween(Short value1, Short value2) {
            addCriterion("DELETE_BY not between", value1, value2, "deleteBy");
            return (Criteria) this;
        }

        public Criteria andDeleteAtIsNull() {
            addCriterion("DELETE_AT is null");
            return (Criteria) this;
        }

        public Criteria andDeleteAtIsNotNull() {
            addCriterion("DELETE_AT is not null");
            return (Criteria) this;
        }

        public Criteria andDeleteAtEqualTo(Date value) {
            addCriterion("DELETE_AT =", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtNotEqualTo(Date value) {
            addCriterion("DELETE_AT <>", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtGreaterThan(Date value) {
            addCriterion("DELETE_AT >", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtGreaterThanOrEqualTo(Date value) {
            addCriterion("DELETE_AT >=", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtLessThan(Date value) {
            addCriterion("DELETE_AT <", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtLessThanOrEqualTo(Date value) {
            addCriterion("DELETE_AT <=", value, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtIn(List<Date> values) {
            addCriterion("DELETE_AT in", values, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtNotIn(List<Date> values) {
            addCriterion("DELETE_AT not in", values, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtBetween(Date value1, Date value2) {
            addCriterion("DELETE_AT between", value1, value2, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andDeleteAtNotBetween(Date value1, Date value2) {
            addCriterion("DELETE_AT not between", value1, value2, "deleteAt");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion("REMARKS is null");
            return (Criteria) this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion("REMARKS is not null");
            return (Criteria) this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion("REMARKS =", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion("REMARKS <>", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion("REMARKS >", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("REMARKS >=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion("REMARKS <", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion("REMARKS <=", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksLike(String value) {
            addCriterion("REMARKS like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotLike(String value) {
            addCriterion("REMARKS not like", value, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksIn(List<String> values) {
            addCriterion("REMARKS in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotIn(List<String> values) {
            addCriterion("REMARKS not in", values, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion("REMARKS between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion("REMARKS not between", value1, value2, "remarks");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIsNull() {
            addCriterion("OPERATOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIsNotNull() {
            addCriterion("OPERATOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorIdEqualTo(Short value) {
            addCriterion("OPERATOR_ID =", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotEqualTo(Short value) {
            addCriterion("OPERATOR_ID <>", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdGreaterThan(Short value) {
            addCriterion("OPERATOR_ID >", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdGreaterThanOrEqualTo(Short value) {
            addCriterion("OPERATOR_ID >=", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLessThan(Short value) {
            addCriterion("OPERATOR_ID <", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLessThanOrEqualTo(Short value) {
            addCriterion("OPERATOR_ID <=", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIn(List<Short> values) {
            addCriterion("OPERATOR_ID in", values, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotIn(List<Short> values) {
            addCriterion("OPERATOR_ID not in", values, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdBetween(Short value1, Short value2) {
            addCriterion("OPERATOR_ID between", value1, value2, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotBetween(Short value1, Short value2) {
            addCriterion("OPERATOR_ID not between", value1, value2, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdIsNull() {
            addCriterion("OP_DEPT_ID is null");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdIsNotNull() {
            addCriterion("OP_DEPT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdEqualTo(Short value) {
            addCriterion("OP_DEPT_ID =", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdNotEqualTo(Short value) {
            addCriterion("OP_DEPT_ID <>", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdGreaterThan(Short value) {
            addCriterion("OP_DEPT_ID >", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdGreaterThanOrEqualTo(Short value) {
            addCriterion("OP_DEPT_ID >=", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdLessThan(Short value) {
            addCriterion("OP_DEPT_ID <", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdLessThanOrEqualTo(Short value) {
            addCriterion("OP_DEPT_ID <=", value, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdIn(List<Short> values) {
            addCriterion("OP_DEPT_ID in", values, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdNotIn(List<Short> values) {
            addCriterion("OP_DEPT_ID not in", values, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdBetween(Short value1, Short value2) {
            addCriterion("OP_DEPT_ID between", value1, value2, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andOpDeptIdNotBetween(Short value1, Short value2) {
            addCriterion("OP_DEPT_ID not between", value1, value2, "opDeptId");
            return (Criteria) this;
        }

        public Criteria andContIdIsNull() {
            addCriterion("CONT_ID is null");
            return (Criteria) this;
        }

        public Criteria andContIdIsNotNull() {
            addCriterion("CONT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andContIdEqualTo(Integer value) {
            addCriterion("CONT_ID =", value, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdNotEqualTo(Integer value) {
            addCriterion("CONT_ID <>", value, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdGreaterThan(Integer value) {
            addCriterion("CONT_ID >", value, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CONT_ID >=", value, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdLessThan(Integer value) {
            addCriterion("CONT_ID <", value, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdLessThanOrEqualTo(Integer value) {
            addCriterion("CONT_ID <=", value, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdIn(List<Integer> values) {
            addCriterion("CONT_ID in", values, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdNotIn(List<Integer> values) {
            addCriterion("CONT_ID not in", values, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdBetween(Integer value1, Integer value2) {
            addCriterion("CONT_ID between", value1, value2, "contId");
            return (Criteria) this;
        }

        public Criteria andContIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CONT_ID not between", value1, value2, "contId");
            return (Criteria) this;
        }

        public Criteria andCusIdIsNull() {
            addCriterion("CUS_ID is null");
            return (Criteria) this;
        }

        public Criteria andCusIdIsNotNull() {
            addCriterion("CUS_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCusIdEqualTo(Integer value) {
            addCriterion("CUS_ID =", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdNotEqualTo(Integer value) {
            addCriterion("CUS_ID <>", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdGreaterThan(Integer value) {
            addCriterion("CUS_ID >", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUS_ID >=", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdLessThan(Integer value) {
            addCriterion("CUS_ID <", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdLessThanOrEqualTo(Integer value) {
            addCriterion("CUS_ID <=", value, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdIn(List<Integer> values) {
            addCriterion("CUS_ID in", values, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdNotIn(List<Integer> values) {
            addCriterion("CUS_ID not in", values, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdBetween(Integer value1, Integer value2) {
            addCriterion("CUS_ID between", value1, value2, "cusId");
            return (Criteria) this;
        }

        public Criteria andCusIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CUS_ID not between", value1, value2, "cusId");
            return (Criteria) this;
        }

        public Criteria andFpTypeIsNull() {
            addCriterion("FP_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andFpTypeIsNotNull() {
            addCriterion("FP_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andFpTypeEqualTo(Short value) {
            addCriterion("FP_TYPE =", value, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeNotEqualTo(Short value) {
            addCriterion("FP_TYPE <>", value, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeGreaterThan(Short value) {
            addCriterion("FP_TYPE >", value, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeGreaterThanOrEqualTo(Short value) {
            addCriterion("FP_TYPE >=", value, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeLessThan(Short value) {
            addCriterion("FP_TYPE <", value, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeLessThanOrEqualTo(Short value) {
            addCriterion("FP_TYPE <=", value, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeIn(List<Short> values) {
            addCriterion("FP_TYPE in", values, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeNotIn(List<Short> values) {
            addCriterion("FP_TYPE not in", values, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeBetween(Short value1, Short value2) {
            addCriterion("FP_TYPE between", value1, value2, "fpType");
            return (Criteria) this;
        }

        public Criteria andFpTypeNotBetween(Short value1, Short value2) {
            addCriterion("FP_TYPE not between", value1, value2, "fpType");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNull() {
            addCriterion("TAX_RATE is null");
            return (Criteria) this;
        }

        public Criteria andTaxRateIsNotNull() {
            addCriterion("TAX_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andTaxRateEqualTo(BigDecimal value) {
            addCriterion("TAX_RATE =", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotEqualTo(BigDecimal value) {
            addCriterion("TAX_RATE <>", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThan(BigDecimal value) {
            addCriterion("TAX_RATE >", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TAX_RATE >=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThan(BigDecimal value) {
            addCriterion("TAX_RATE <", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TAX_RATE <=", value, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateIn(List<BigDecimal> values) {
            addCriterion("TAX_RATE in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotIn(List<BigDecimal> values) {
            addCriterion("TAX_RATE not in", values, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TAX_RATE between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andTaxRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TAX_RATE not between", value1, value2, "taxRate");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNull() {
            addCriterion("MONEY is null");
            return (Criteria) this;
        }

        public Criteria andMoneyIsNotNull() {
            addCriterion("MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyEqualTo(BigDecimal value) {
            addCriterion("MONEY =", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotEqualTo(BigDecimal value) {
            addCriterion("MONEY <>", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThan(BigDecimal value) {
            addCriterion("MONEY >", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MONEY >=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThan(BigDecimal value) {
            addCriterion("MONEY <", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MONEY <=", value, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyIn(List<BigDecimal> values) {
            addCriterion("MONEY in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotIn(List<BigDecimal> values) {
            addCriterion("MONEY not in", values, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MONEY between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MONEY not between", value1, value2, "money");
            return (Criteria) this;
        }

        public Criteria andReceiveDateIsNull() {
            addCriterion("RECEIVE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andReceiveDateIsNotNull() {
            addCriterion("RECEIVE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveDateEqualTo(Date value) {
            addCriterion("RECEIVE_DATE =", value, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateNotEqualTo(Date value) {
            addCriterion("RECEIVE_DATE <>", value, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateGreaterThan(Date value) {
            addCriterion("RECEIVE_DATE >", value, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateGreaterThanOrEqualTo(Date value) {
            addCriterion("RECEIVE_DATE >=", value, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateLessThan(Date value) {
            addCriterion("RECEIVE_DATE <", value, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateLessThanOrEqualTo(Date value) {
            addCriterion("RECEIVE_DATE <=", value, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateIn(List<Date> values) {
            addCriterion("RECEIVE_DATE in", values, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateNotIn(List<Date> values) {
            addCriterion("RECEIVE_DATE not in", values, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateBetween(Date value1, Date value2) {
            addCriterion("RECEIVE_DATE between", value1, value2, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andReceiveDateNotBetween(Date value1, Date value2) {
            addCriterion("RECEIVE_DATE not between", value1, value2, "receiveDate");
            return (Criteria) this;
        }

        public Criteria andCusAddressIsNull() {
            addCriterion("CUS_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andCusAddressIsNotNull() {
            addCriterion("CUS_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andCusAddressEqualTo(String value) {
            addCriterion("CUS_ADDRESS =", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressNotEqualTo(String value) {
            addCriterion("CUS_ADDRESS <>", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressGreaterThan(String value) {
            addCriterion("CUS_ADDRESS >", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressGreaterThanOrEqualTo(String value) {
            addCriterion("CUS_ADDRESS >=", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressLessThan(String value) {
            addCriterion("CUS_ADDRESS <", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressLessThanOrEqualTo(String value) {
            addCriterion("CUS_ADDRESS <=", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressLike(String value) {
            addCriterion("CUS_ADDRESS like", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressNotLike(String value) {
            addCriterion("CUS_ADDRESS not like", value, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressIn(List<String> values) {
            addCriterion("CUS_ADDRESS in", values, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressNotIn(List<String> values) {
            addCriterion("CUS_ADDRESS not in", values, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressBetween(String value1, String value2) {
            addCriterion("CUS_ADDRESS between", value1, value2, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusAddressNotBetween(String value1, String value2) {
            addCriterion("CUS_ADDRESS not between", value1, value2, "cusAddress");
            return (Criteria) this;
        }

        public Criteria andCusItinIsNull() {
            addCriterion("CUS_ITIN is null");
            return (Criteria) this;
        }

        public Criteria andCusItinIsNotNull() {
            addCriterion("CUS_ITIN is not null");
            return (Criteria) this;
        }

        public Criteria andCusItinEqualTo(String value) {
            addCriterion("CUS_ITIN =", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinNotEqualTo(String value) {
            addCriterion("CUS_ITIN <>", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinGreaterThan(String value) {
            addCriterion("CUS_ITIN >", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinGreaterThanOrEqualTo(String value) {
            addCriterion("CUS_ITIN >=", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinLessThan(String value) {
            addCriterion("CUS_ITIN <", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinLessThanOrEqualTo(String value) {
            addCriterion("CUS_ITIN <=", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinLike(String value) {
            addCriterion("CUS_ITIN like", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinNotLike(String value) {
            addCriterion("CUS_ITIN not like", value, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinIn(List<String> values) {
            addCriterion("CUS_ITIN in", values, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinNotIn(List<String> values) {
            addCriterion("CUS_ITIN not in", values, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinBetween(String value1, String value2) {
            addCriterion("CUS_ITIN between", value1, value2, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusItinNotBetween(String value1, String value2) {
            addCriterion("CUS_ITIN not between", value1, value2, "cusItin");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankIsNull() {
            addCriterion("CUS_OPENING_BANK is null");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankIsNotNull() {
            addCriterion("CUS_OPENING_BANK is not null");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankEqualTo(String value) {
            addCriterion("CUS_OPENING_BANK =", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankNotEqualTo(String value) {
            addCriterion("CUS_OPENING_BANK <>", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankGreaterThan(String value) {
            addCriterion("CUS_OPENING_BANK >", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankGreaterThanOrEqualTo(String value) {
            addCriterion("CUS_OPENING_BANK >=", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankLessThan(String value) {
            addCriterion("CUS_OPENING_BANK <", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankLessThanOrEqualTo(String value) {
            addCriterion("CUS_OPENING_BANK <=", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankLike(String value) {
            addCriterion("CUS_OPENING_BANK like", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankNotLike(String value) {
            addCriterion("CUS_OPENING_BANK not like", value, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankIn(List<String> values) {
            addCriterion("CUS_OPENING_BANK in", values, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankNotIn(List<String> values) {
            addCriterion("CUS_OPENING_BANK not in", values, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankBetween(String value1, String value2) {
            addCriterion("CUS_OPENING_BANK between", value1, value2, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusOpeningBankNotBetween(String value1, String value2) {
            addCriterion("CUS_OPENING_BANK not between", value1, value2, "cusOpeningBank");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountIsNull() {
            addCriterion("CUS_BANK_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountIsNotNull() {
            addCriterion("CUS_BANK_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountEqualTo(String value) {
            addCriterion("CUS_BANK_ACCOUNT =", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountNotEqualTo(String value) {
            addCriterion("CUS_BANK_ACCOUNT <>", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountGreaterThan(String value) {
            addCriterion("CUS_BANK_ACCOUNT >", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("CUS_BANK_ACCOUNT >=", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountLessThan(String value) {
            addCriterion("CUS_BANK_ACCOUNT <", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountLessThanOrEqualTo(String value) {
            addCriterion("CUS_BANK_ACCOUNT <=", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountLike(String value) {
            addCriterion("CUS_BANK_ACCOUNT like", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountNotLike(String value) {
            addCriterion("CUS_BANK_ACCOUNT not like", value, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountIn(List<String> values) {
            addCriterion("CUS_BANK_ACCOUNT in", values, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountNotIn(List<String> values) {
            addCriterion("CUS_BANK_ACCOUNT not in", values, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountBetween(String value1, String value2) {
            addCriterion("CUS_BANK_ACCOUNT between", value1, value2, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andCusBankAccountNotBetween(String value1, String value2) {
            addCriterion("CUS_BANK_ACCOUNT not between", value1, value2, "cusBankAccount");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeIsNull() {
            addCriterion("VOUCHER_CODE is null");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeIsNotNull() {
            addCriterion("VOUCHER_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeEqualTo(String value) {
            addCriterion("VOUCHER_CODE =", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotEqualTo(String value) {
            addCriterion("VOUCHER_CODE <>", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeGreaterThan(String value) {
            addCriterion("VOUCHER_CODE >", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeGreaterThanOrEqualTo(String value) {
            addCriterion("VOUCHER_CODE >=", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeLessThan(String value) {
            addCriterion("VOUCHER_CODE <", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeLessThanOrEqualTo(String value) {
            addCriterion("VOUCHER_CODE <=", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeLike(String value) {
            addCriterion("VOUCHER_CODE like", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotLike(String value) {
            addCriterion("VOUCHER_CODE not like", value, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeIn(List<String> values) {
            addCriterion("VOUCHER_CODE in", values, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotIn(List<String> values) {
            addCriterion("VOUCHER_CODE not in", values, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeBetween(String value1, String value2) {
            addCriterion("VOUCHER_CODE between", value1, value2, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherCodeNotBetween(String value1, String value2) {
            addCriterion("VOUCHER_CODE not between", value1, value2, "voucherCode");
            return (Criteria) this;
        }

        public Criteria andVoucherDateIsNull() {
            addCriterion("VOUCHER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andVoucherDateIsNotNull() {
            addCriterion("VOUCHER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andVoucherDateEqualTo(String value) {
            addCriterion("VOUCHER_DATE =", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotEqualTo(String value) {
            addCriterion("VOUCHER_DATE <>", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateGreaterThan(String value) {
            addCriterion("VOUCHER_DATE >", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateGreaterThanOrEqualTo(String value) {
            addCriterion("VOUCHER_DATE >=", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateLessThan(String value) {
            addCriterion("VOUCHER_DATE <", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateLessThanOrEqualTo(String value) {
            addCriterion("VOUCHER_DATE <=", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateLike(String value) {
            addCriterion("VOUCHER_DATE like", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotLike(String value) {
            addCriterion("VOUCHER_DATE not like", value, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateIn(List<String> values) {
            addCriterion("VOUCHER_DATE in", values, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotIn(List<String> values) {
            addCriterion("VOUCHER_DATE not in", values, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateBetween(String value1, String value2) {
            addCriterion("VOUCHER_DATE between", value1, value2, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherDateNotBetween(String value1, String value2) {
            addCriterion("VOUCHER_DATE not between", value1, value2, "voucherDate");
            return (Criteria) this;
        }

        public Criteria andVoucherOpIsNull() {
            addCriterion("VOUCHER_OP is null");
            return (Criteria) this;
        }

        public Criteria andVoucherOpIsNotNull() {
            addCriterion("VOUCHER_OP is not null");
            return (Criteria) this;
        }

        public Criteria andVoucherOpEqualTo(String value) {
            addCriterion("VOUCHER_OP =", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotEqualTo(String value) {
            addCriterion("VOUCHER_OP <>", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpGreaterThan(String value) {
            addCriterion("VOUCHER_OP >", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpGreaterThanOrEqualTo(String value) {
            addCriterion("VOUCHER_OP >=", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpLessThan(String value) {
            addCriterion("VOUCHER_OP <", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpLessThanOrEqualTo(String value) {
            addCriterion("VOUCHER_OP <=", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpLike(String value) {
            addCriterion("VOUCHER_OP like", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotLike(String value) {
            addCriterion("VOUCHER_OP not like", value, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpIn(List<String> values) {
            addCriterion("VOUCHER_OP in", values, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotIn(List<String> values) {
            addCriterion("VOUCHER_OP not in", values, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpBetween(String value1, String value2) {
            addCriterion("VOUCHER_OP between", value1, value2, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andVoucherOpNotBetween(String value1, String value2) {
            addCriterion("VOUCHER_OP not between", value1, value2, "voucherOp");
            return (Criteria) this;
        }

        public Criteria andIsCancelledIsNull() {
            addCriterion("IS_CANCELLED is null");
            return (Criteria) this;
        }

        public Criteria andIsCancelledIsNotNull() {
            addCriterion("IS_CANCELLED is not null");
            return (Criteria) this;
        }

        public Criteria andIsCancelledEqualTo(String value) {
            addCriterion("IS_CANCELLED =", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotEqualTo(String value) {
            addCriterion("IS_CANCELLED <>", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledGreaterThan(String value) {
            addCriterion("IS_CANCELLED >", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledGreaterThanOrEqualTo(String value) {
            addCriterion("IS_CANCELLED >=", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledLessThan(String value) {
            addCriterion("IS_CANCELLED <", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledLessThanOrEqualTo(String value) {
            addCriterion("IS_CANCELLED <=", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledLike(String value) {
            addCriterion("IS_CANCELLED like", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotLike(String value) {
            addCriterion("IS_CANCELLED not like", value, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledIn(List<String> values) {
            addCriterion("IS_CANCELLED in", values, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotIn(List<String> values) {
            addCriterion("IS_CANCELLED not in", values, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledBetween(String value1, String value2) {
            addCriterion("IS_CANCELLED between", value1, value2, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsCancelledNotBetween(String value1, String value2) {
            addCriterion("IS_CANCELLED not between", value1, value2, "isCancelled");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("IS_DELETED is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("IS_DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(String value) {
            addCriterion("IS_DELETED =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(String value) {
            addCriterion("IS_DELETED <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(String value) {
            addCriterion("IS_DELETED >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DELETED >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(String value) {
            addCriterion("IS_DELETED <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(String value) {
            addCriterion("IS_DELETED <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(String value) {
            addCriterion("IS_DELETED like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(String value) {
            addCriterion("IS_DELETED not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<String> values) {
            addCriterion("IS_DELETED in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<String> values) {
            addCriterion("IS_DELETED not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(String value1, String value2) {
            addCriterion("IS_DELETED between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(String value1, String value2) {
            addCriterion("IS_DELETED not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andContIdStrIsNull() {
            addCriterion("CONT_ID_STR is null");
            return (Criteria) this;
        }

        public Criteria andContIdStrIsNotNull() {
            addCriterion("CONT_ID_STR is not null");
            return (Criteria) this;
        }

        public Criteria andContIdStrEqualTo(String value) {
            addCriterion("CONT_ID_STR =", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrNotEqualTo(String value) {
            addCriterion("CONT_ID_STR <>", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrGreaterThan(String value) {
            addCriterion("CONT_ID_STR >", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrGreaterThanOrEqualTo(String value) {
            addCriterion("CONT_ID_STR >=", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrLessThan(String value) {
            addCriterion("CONT_ID_STR <", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrLessThanOrEqualTo(String value) {
            addCriterion("CONT_ID_STR <=", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrLike(String value) {
            addCriterion("CONT_ID_STR like", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrNotLike(String value) {
            addCriterion("CONT_ID_STR not like", value, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrIn(List<String> values) {
            addCriterion("CONT_ID_STR in", values, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrNotIn(List<String> values) {
            addCriterion("CONT_ID_STR not in", values, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrBetween(String value1, String value2) {
            addCriterion("CONT_ID_STR between", value1, value2, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andContIdStrNotBetween(String value1, String value2) {
            addCriterion("CONT_ID_STR not between", value1, value2, "contIdStr");
            return (Criteria) this;
        }

        public Criteria andIsReceivedIsNull() {
            addCriterion("IS_RECEIVED is null");
            return (Criteria) this;
        }

        public Criteria andIsReceivedIsNotNull() {
            addCriterion("IS_RECEIVED is not null");
            return (Criteria) this;
        }

        public Criteria andIsReceivedEqualTo(String value) {
            addCriterion("IS_RECEIVED =", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedNotEqualTo(String value) {
            addCriterion("IS_RECEIVED <>", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedGreaterThan(String value) {
            addCriterion("IS_RECEIVED >", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedGreaterThanOrEqualTo(String value) {
            addCriterion("IS_RECEIVED >=", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedLessThan(String value) {
            addCriterion("IS_RECEIVED <", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedLessThanOrEqualTo(String value) {
            addCriterion("IS_RECEIVED <=", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedLike(String value) {
            addCriterion("IS_RECEIVED like", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedNotLike(String value) {
            addCriterion("IS_RECEIVED not like", value, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedIn(List<String> values) {
            addCriterion("IS_RECEIVED in", values, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedNotIn(List<String> values) {
            addCriterion("IS_RECEIVED not in", values, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedBetween(String value1, String value2) {
            addCriterion("IS_RECEIVED between", value1, value2, "isReceived");
            return (Criteria) this;
        }

        public Criteria andIsReceivedNotBetween(String value1, String value2) {
            addCriterion("IS_RECEIVED not between", value1, value2, "isReceived");
            return (Criteria) this;
        }

        public Criteria andCancelledAtIsNull() {
            addCriterion("CANCELLED_AT is null");
            return (Criteria) this;
        }

        public Criteria andCancelledAtIsNotNull() {
            addCriterion("CANCELLED_AT is not null");
            return (Criteria) this;
        }

        public Criteria andCancelledAtEqualTo(Date value) {
            addCriterion("CANCELLED_AT =", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtNotEqualTo(Date value) {
            addCriterion("CANCELLED_AT <>", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtGreaterThan(Date value) {
            addCriterion("CANCELLED_AT >", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtGreaterThanOrEqualTo(Date value) {
            addCriterion("CANCELLED_AT >=", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtLessThan(Date value) {
            addCriterion("CANCELLED_AT <", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtLessThanOrEqualTo(Date value) {
            addCriterion("CANCELLED_AT <=", value, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtIn(List<Date> values) {
            addCriterion("CANCELLED_AT in", values, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtNotIn(List<Date> values) {
            addCriterion("CANCELLED_AT not in", values, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtBetween(Date value1, Date value2) {
            addCriterion("CANCELLED_AT between", value1, value2, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCancelledAtNotBetween(Date value1, Date value2) {
            addCriterion("CANCELLED_AT not between", value1, value2, "cancelledAt");
            return (Criteria) this;
        }

        public Criteria andCheckMemoIsNull() {
            addCriterion("CHECK_MEMO is null");
            return (Criteria) this;
        }

        public Criteria andCheckMemoIsNotNull() {
            addCriterion("CHECK_MEMO is not null");
            return (Criteria) this;
        }

        public Criteria andCheckMemoEqualTo(String value) {
            addCriterion("CHECK_MEMO =", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotEqualTo(String value) {
            addCriterion("CHECK_MEMO <>", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoGreaterThan(String value) {
            addCriterion("CHECK_MEMO >", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoGreaterThanOrEqualTo(String value) {
            addCriterion("CHECK_MEMO >=", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoLessThan(String value) {
            addCriterion("CHECK_MEMO <", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoLessThanOrEqualTo(String value) {
            addCriterion("CHECK_MEMO <=", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoLike(String value) {
            addCriterion("CHECK_MEMO like", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotLike(String value) {
            addCriterion("CHECK_MEMO not like", value, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoIn(List<String> values) {
            addCriterion("CHECK_MEMO in", values, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotIn(List<String> values) {
            addCriterion("CHECK_MEMO not in", values, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoBetween(String value1, String value2) {
            addCriterion("CHECK_MEMO between", value1, value2, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andCheckMemoNotBetween(String value1, String value2) {
            addCriterion("CHECK_MEMO not between", value1, value2, "checkMemo");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeIsNull() {
            addCriterion("RECEIVE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeIsNotNull() {
            addCriterion("RECEIVE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeEqualTo(String value) {
            addCriterion("RECEIVE_TYPE =", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotEqualTo(String value) {
            addCriterion("RECEIVE_TYPE <>", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeGreaterThan(String value) {
            addCriterion("RECEIVE_TYPE >", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeGreaterThanOrEqualTo(String value) {
            addCriterion("RECEIVE_TYPE >=", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeLessThan(String value) {
            addCriterion("RECEIVE_TYPE <", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeLessThanOrEqualTo(String value) {
            addCriterion("RECEIVE_TYPE <=", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeLike(String value) {
            addCriterion("RECEIVE_TYPE like", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotLike(String value) {
            addCriterion("RECEIVE_TYPE not like", value, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeIn(List<String> values) {
            addCriterion("RECEIVE_TYPE in", values, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotIn(List<String> values) {
            addCriterion("RECEIVE_TYPE not in", values, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeBetween(String value1, String value2) {
            addCriterion("RECEIVE_TYPE between", value1, value2, "receiveType");
            return (Criteria) this;
        }

        public Criteria andReceiveTypeNotBetween(String value1, String value2) {
            addCriterion("RECEIVE_TYPE not between", value1, value2, "receiveType");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}